Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator
110 Search Results Found
1 Forum: SQL & PL/SQL «» Posted on: Tue, 17 September 2024 14:08 «» By: PPOraFaq
Re: ORA-29005: The certificate is invalid
…* FROM DBA_HOST_ACES WHERE PRINCIPAL = 'MYUSER'; HOST,LOWER_PORT,UPPER_PORT,ACE_ORDER,START_DATE,END_DATE,GRANT_TYPE,INVERTED_PRINCIPAL,PRINCIPAL,PRINCIPAL_TYPE,PRIVILEGE *,,,2,,,GRANT,NO,MYUSER,DATABASE,RESOLVE *,,,2,,,GRANT,NO,MYUSER,DATABASE,…
2 Forum: Backup & Recovery «» Posted on: Thu, 06 July 2023 07:01 «» By: Andrey_R
RMAN restore - only DB backup ( no SF\CF\archivelog backup )
…a scenario when I want to restore a table MYUSER.T1 from a previous date. I have no archive log backups, no SPFILE/CTL file backups. I only have a backup of the database from a time I want to restore the table to. I do have a SPFILE/Control …
3 Forum: Server Utilities «» Posted on: Mon, 15 April 2024 21:19 «» By: wtolentino
impd data only on the same database from one table to another table
… I tried this impdp with no success impdp myUser@myDB/****** tables=myUser.sample_tab_import01 content=data_only remap_table=myUser.sample_tab_import01:sample_tab_import02 table_exists_action=truncate nologfile=yes 1>impdp_myDB.log 2>&1 I …
4 Forum: Backup & Recovery «» Posted on: Thu, 06 July 2023 09:41 «» By: Andrey_R
Re: RMAN restore - only DB backup ( no SF\CF\archivelog backup )
… RMAN> RUN { 2> RESTORE TABLE "MYUSER"."T1"; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571…
5 Forum: Backup & Recovery «» Posted on: Fri, 07 July 2023 05:28 «» By: Andrey_R
Re: RMAN restore - only DB backup ( no SF\CF\archivelog backup )
…! And I was surprised to see that my table MYUSER.T1 was missing from it!  8o .. I wonder whether it's the corruption in the files I "allowed" or something in my technique that caused this.. But I did expect that I could at least …
6 Forum: Backup & Recovery «» Posted on: Thu, 06 July 2023 07:57 «» By: Andrey_R
Re: RMAN restore - only DB backup ( no SF\CF\archivelog backup )
…result RMAN> RECOVER TABLE "MYUSER"."T1" 2> UNTIL TIME "TO_DATE('06.07.2023 11:47:00', 'DD-MM-YYYY HH24:MI:SS')" 3> AUXILIARY DESTINATION 'G:\MYAUX' 4> REMAP TABLE 'MYUSER'.'T1':'T1_RECOVERED'; Starting…
7 Forum: SQL & PL/SQL «» Posted on: Fri, 29 October 2021 15:35 «» By: Andrey_R
Re: Data Dictionary for Collection Bind variables
… It errors for me: C:\Users\myuser>sqlplus a/a SQL*Plus: Release 18.0.0.0.0 - Production on Fri Oct 29 23:32:58 2021 Version 18.4.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Last Successful login time: Fri Oct 29 2021 …
8 Forum: SQL & PL/SQL «» Posted on: Wed, 27 October 2021 08:44 «» By: Andrey_R
Re: Data Dictionary for Collection Bind variables
… Try this Session 1: C:\Users\myuser>sqlplus a/a SQL*Plus: Release 18.0.0.0.0 - Production on Wed Oct 27 16:37:00 2021 Version 18.4.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Last Successful login time: Wed …
9 Forum: Performance Tuning «» Posted on: Thu, 11 February 2021 06:19 «» By: Andrey_R
TKPROF showing wrong totals for non-recursive statements
…file, which I tkprof'ed with C:\...myuser>tkprof D:\SOMEPATH...\MYDB_ora_26950.trc D:\SOMEPATH...\MYDB_ora_26950.tkprf sort=exeela,fchela,prsela TKPROF: Release 12.1.0.2.0 - Development on Thu Feb 11 11:16:34 2021 Copyright (c) 1982, 2014…
10 Forum: Server Administration «» Posted on: Wed, 18 November 2020 03:22 «» By: Andrey_R
Re: ORA-24079:names with AQ$_ prefix are not valid for QUEUE_TABLE
…regular drop table: SQL> Alter session set events '10851 trace name context forever, level 2'; Session altered. SQL> drop table MYUSER.AQ$_SOMELOGIC_QTABLE_L; Table dropped. SQL> It worked !!! Great thanks Michel…
11 Forum: Server Administration «» Posted on: Tue, 17 November 2020 11:58 «» By: Andrey_R
Re: ORA-24079:names with AQ$_ prefix are not valid for QUEUE_TABLE
…ist: SQL> show user USER is "MYUSER" SQL> SQL> SQL> col owner for a30 SQL> col table_name for a50 SQL> SQL> select owner,table_name from dba_tables where owner = user and table_name like 'AQ$%'; OWNER…
12 Forum: Server Administration «» Posted on: Tue, 17 November 2020 11:27 «» By: Andrey_R
Re: ORA-24079:names with AQ$_ prefix are not valid for QUEUE_TABLE
… SQL> SQL> show user USER is "MYUSER" SQL> SQL> SQL> select owner,name,queue_table,queue_type 2 from dba_queues 3 where owner = 'MYUSER' 4 order by 1, 2, 3; no rows selected SQL> SQL> SQL> SQL>…
13 Forum: Server Administration «» Posted on: Sun, 08 November 2020 06:04 «» By: Andrey_R
Re: ORA-24079:names with AQ$_ prefix are not valid for QUEUE_TABLE
… time I hope. I am querying the queues of MYUSER, no results: Connected to: Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production SQL> conn MYUSER/password@connstring Connected. SQL> SQL> SQL> select * from …
14 Forum: Server Administration «» Posted on: Thu, 29 October 2020 10:54 «» By: Andrey_R
ORA-24079:names with AQ$_ prefix are not valid for QUEUE_TABLE
…= 'AQ$_SOMELOGIC_QTABLE' AND OWNER = 'MYUSER'; OWNER TABLE_NAME STATUS ------------------------------ ----------------------------------- -------------------- MYUSER AQ$…
15 Forum: Security «» Posted on: Sun, 09 August 2020 07:34 «» By: Andrey_R
Re: Username in lowercase authentication issues
…database: C:\Documents and Settings\myuser>sqlplus "test"/"test"@mydb SQL*Plus: Release 10.2.0.1.0 - Production on Sun Aug 9 15:24:45 2020 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-01017: …
16 Forum: Security «» Posted on: Sun, 09 August 2020 05:44 «» By: Andrey_R
Re: Username in lowercase authentication issues
…Corp. C:\Documents and Settings\myuser>sqlplus "test"/"test"@mydb SQL*Plus: Release 10.2.0.1.0 - Production on Sun Aug 9 13:40:55 2020 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-01017: invalid …
17 Forum: SQL & PL/SQL «» Posted on: Wed, 15 July 2020 04:36 «» By: Andrey_R
How to Inherit data default from %TYPE attribute for a variable
…: ORA-01400: cannot insert NULL into ("MYUSER"."TEST"."COL1") ORA-06512: at line 4 I did read some documentation saying I can't do that in here => https://docs.oracle.com/cd/B28359_01/appdev.111/b28370/…
18 Forum: SQL & PL/SQL «» Posted on: Thu, 17 January 2019 12:00 «» By: Andrey_R
ORA-01843 on a simple query
… from dual * ERROR at line 1: ORA-00911: invalid character SQL> show user USER is "MYUSER" SQL> Any ideas where is it coming from, what am I missing ? TIA …
19 Forum: Performance Tuning «» Posted on: Thu, 01 November 2018 04:31 «» By: Andrey_R
Re: Optimal Chunk size for update of 50M record table
… 0 Rowid Range Scan: MYUSER.MYTAB: 20149 out of 221372 Blocks done 6 100554 .986644979026% 17 0 Rowid Range Scan: MYUSER.MYTAB: 2305 out of 233620 Blocks done…
20 Forum: Performance Tuning «» Posted on: Wed, 31 October 2018 13:31 «» By: Andrey_R
Re: Optimal Chunk size for update of 50M record table
… 0 Rowid Range Scan: MYUSER.MYTAB: 17237 out of 298731 Blocks done 73674 7.11329195637% 94 0 Rowid Range Scan: MYUSER.MYTAB: 16584 out of 233141 Blocks done 72710 …
21 Forum: Performance Tuning «» Posted on: Wed, 31 October 2018 08:50 «» By: Andrey_R
Re: Optimal Chunk size for update of 50M record table
… 0 Rowid Range Scan: MYUSER.MYTAB: 19943 out of 233491 Blocks done 52366 8.617250011849% 82 0 Rowid Range Scan: MYUSER.MYTAB: 19999 out of 232081 Blocks done 52205 …
22 Forum: Networking and Gateways «» Posted on: Mon, 29 October 2018 12:26 «» By: JPBoileau
Re: Unsuccessful of establishment of database link from oracle to sql server
…DS_TRACE_LEVEL=ON HS_FDS_RECOVERY_ACCOUNT=myuser HS_FDS_RECOVERY_PWD=mypwd 3) A TNSNames Entry in the Database Oracle Home that points to the listener defined in 1) above with the "HS = OK" parameter DG4MSQL = (DESCRIPTION…
23 Forum: SQL & PL/SQL «» Posted on: Mon, 29 October 2018 10:57 «» By: Andrey_R
Re: date column displays strange output
…g.DATECOL1 < to_date('01/01/2000', 'dd/mm/yyyy'); select distinct bad_date(dt => g.DATECOL1 ) from MYTAB g * ERROR at line 1: ORA-01843: not a valid month ORA-06512: at "MYUSER.BAD_DATE", line 21 SQL>…
24 Forum: Security «» Posted on: Wed, 25 July 2018 07:25 «» By: EdStevens
Re: Authentication and passwordfile
… if you request a TNS connection: sqlplus myuser/mypassword@mydatabase THEN authentication will be to consult the password file for 'mydatabase', to see if there is an entry for 'myuser' and that his password is 'mypassword'. And with TNS …
25 Forum: General «» Posted on: Mon, 08 January 2018 07:59 «» By: BlackSwan
Re: SQL Report running manually not through cron
You can create & SQLPLUS will utilize your own private copy of tnsnmes.ora when named as below /data/myuser/user1/.tnsnames.ora Notice that there is a dot (".") preceding and as part of actual filename.
26 Forum: General «» Posted on: Fri, 05 January 2018 21:54 «» By: dba4oracle
Re: SQL Report running manually not through cron
… below is env.capture HOME=/data/myuser/user1 HOST=IAPL1 LANG=en_US.UTF-8 LOGNAME=user1 MAILTO=myuser@mycompany.com ORACLE_HOME=/opt/u01/app/oracle/product/11.2.0.4/client PASSWORD=abc123 PATH=/opt/u01/app/oracle/product/11.2.0.4/client…
27 Forum: SQL & PL/SQL «» Posted on: Mon, 19 September 2016 06:37 «» By: bluetooth420
Re: Missing Record in running Total
…quot;MOS"."VCUSTHIST1" ("MYUSER", "TTYPE", "CCODE", "CODE", "CNAME", "DATED", "DETAIL", "AMOUNT", "AORS", "REF", "REMARKS") AS…
28 Forum: SQL & PL/SQL «» Posted on: Wed, 08 June 2016 07:39 «» By: EdStevens
Re: How To Update Encrypted Password for all user id's using Update Query
Really? Have you seen what happens when you 'sqlplus myuser/p@ssword123@mydb'
29 Forum: SQL & PL/SQL «» Posted on: Fri, 18 December 2015 13:55 «» By: EdStevens
Re: dbms_ldap.simple_bind_s doesn't work with PW containing "!"
… denoted by a "@" (as in 'sqlplus myuser/mypwd@orcl'), if the password is also included and the password contains an "@", it causes the parser to short the password and try to make the rest of it the connect string. I've also known …
30 Forum: Server Administration «» Posted on: Mon, 16 November 2015 09:01 «» By: pkirklewski
Re: TNS-03502: Message 3502 not found
…file and now tnsping gives me: C:\Users\MyUser>tnsping MyDATABASE 1 TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 16-NOV-2015 14:55:59 Copyright (c) 1997, 2010, Oracle. All rights reserved. Used parameter files…
31 Forum: Server Administration «» Posted on: Mon, 16 November 2015 08:12 «» By: pkirklewski
Re: TNS-03502: Message 3502 not found
… C:\Users\MyUser>set ORACLE_HOME=D:\Oracle\product\11.2.0\client_4 C:\Users\MyUser>set PATH=%ORACLE_HOME%\bin;%PATH% C:\Users\MyUser>where tnsping D:\Oracle\product\11.2.0\client_4\bin\tnsping.exe C:\Users\MyUser>tnsping TNS Ping…
32 Forum: Server Administration «» Posted on: Mon, 16 November 2015 07:42 «» By: pkirklewski
Re: TNS-03502: Message 3502 not found
…ow, maybe I've missed smething ? C:\Users\MyUser>echo %PATH% C:\Program Files (x86)\Common Files\Microsoft BizTalk Adapters for Enterprise Applications\Bin\;D:\Oracle\product\11.2.0\client_4\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\…
33 Forum: Server Administration «» Posted on: Mon, 16 November 2015 06:29 «» By: pkirklewski
TNS-03502: Message 3502 not found
…I run tnsping command, I get : C:\Users\MyUser>tnsping TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 16-NOV-2015 12:08:08 Copyright (c) 1997, 2010, Oracle. All rights reserved. TNS-03502: Message 3502 not found; No …
34 Forum: Performance Tuning «» Posted on: Mon, 09 March 2015 14:30 «» By: bluetooth420
Re: Same Data, Two machines but different timings. Why?
… of master detail inv0s Name Null? Type MYUSER NOT NULL VARCHAR2(10) INVNO NOT NULL NUMBER(6) ADDAID NOT NULL NUMBER(3) CCODE NOT NULL NUMBER(3) INVDATE NOT NULL DATE CORD NOT NULL VARCHAR2(1) REMARKS VARCHAR2(80) RETURN2 NOT NULL VARCHAR2(1…
35 Forum: Server Utilities «» Posted on: Wed, 13 August 2014 06:32 «» By: superuser
Re: expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780
…0.2.0.1.0 - 64bit Production Starting "MYUSER"."SYS_EXPORT_SCHEMA_04": myuser/********@wtwora directory=DMP dumpfile=wtwora.dmp logfile=wtwora.log schemas=WTWORA,SIMONE Estimate in progress using BLOCKS method... Processing object…
36 Forum: Server Utilities «» Posted on: Wed, 13 August 2014 06:02 «» By: superuser
Re: expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780
…body SYS.KUPW$WORKER 000000036A7D9CB8 1262 package body SYS.KUPW$WORKER 000000036BC1DEF0 2 anonymous block Job "MYUSER"."SYS_EXPORT_SCHEMA_04" stopped due to fatal error at 12:22:05 [LF applied [spoiler] tags…
37 Forum: Server Utilities «» Posted on: Wed, 13 August 2014 05:27 «» By: superuser
expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780
…. I created proper user: create user myuser identified by somepassword; grant connect,dba,resource,exp_full_database,imp_full_database to myuser; create or replace directory DMP as 'F:\DMP\'; grant read, write on directory DMP to myuser; …
38 Forum: SQL & PL/SQL «» Posted on: Thu, 29 May 2014 16:04 «» By: evivekj
Re: how to write an excel in PLSQL
… GRANT READ, WRITE ON DIRECTORY TEST_DIR TO myuser / As myuser: DECLARE v_fh UTL_FILE.FILE_TYPE; v_dir VARCHAR2(30) := 'TEST_DIR'; v_file VARCHAR2(30) := 'myfile.xls'; PROCEDURE run_query(p_sql IN VARCHAR2) IS…
39 Forum: SQL & PL/SQL «» Posted on: Tue, 21 January 2014 00:45 «» By: Manoj.Gupta.91
Re: Issue in Database Link
… CREATE DATABASE LINK DBLNK_DB2 CONNECT TO myuser IDENTIFIED BY myuser USING 'DB2' ; When I tried to create db link as below. There was still an issue. CREATE DATABASE LINK DBLNK_DB2 CONNECT TO myuser IDENTIFIED BY myuser USING '10.10…
40 Forum: SQL & PL/SQL «» Posted on: Mon, 20 January 2014 23:55 «» By: Manoj.Gupta.91
Issue in Database Link
… CREATE DATABASE LINK DBLNK_DB2 CONNECT TO myuser IDENTIFIED BY myuser USING '10.10.1.250:1521/DB2' ; SELECT * FROM myuser.mytable@DBLNK_DB2 ; --above query is giving below error. ORA-12154: TNS:could not resolve the connect identifier …
Pages (3): [1  2  3  ›  »]

Current Time: Mon Nov 25 00:53:10 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.